package com.xs.entity;

import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
/**
 * 用户表t_user
 *CREATE TABLE t_user(
 *ID INT(10)PRIMARY KEY NOT NULL AUTO_INCREMENT,
 *USER_NAME VARCHAR(40),
 *USER_PWD VARCHAR(60),
 *USER_REALNAME VARCHAR(40),
 *USER_GENDER CHAR(2),
 *USER_EMAIL VARCHAR(60)UNIQUE,
 *USER_PHONE CHAR(11)UNIQUE,
 *USER_ID CHAR(18)UNIQUE,
 *USER_BIRTHDATE DATE,
 *USER_LOCK INT(1),
 *USER_ADDRESS VARCHAR(255),
 *USER_IMAGE VARCHAR(255)
 *)ENGINE=INNODB DEFAULT CHARSET=utf8;
 */

@Data
public class User {
    //@ExcelProperty("编号")//给导出的属性起别名
    private Integer id;
    //@ExcelProperty("姓名")
    private String userName;
    private String userPwd;
    private String userRealname;
    private String userGender;
    private String userEmail;
    private String userPhone;
    private String userId;
    // @DateTimeFormat: 日期时间格式((pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private Date userBirthdate;
    private Integer userLock;
    private String userAddress;
    //@ExcelIgnore//不导出该属性
    private String userImage;
}
